获取项目的指标数据_接入层

描述

导出多张表的分钟级读写次数等各种监控指标

请求地址

/v2/webservice/report/proxy-stats-min-period

请求方法

Post

请求参数说明

字段名字段说明类型是否必填描述参考值
set_id集群IDnumber是1
app_id项目IDnumber是2
zone_id区IDnumber否为否的时候表示，本项目整个集群下的汇总指标3
proxy_id进程IDstring否查询具体的进程级别的的指标
report_begin_date开始时间string是开始时间和结束时间跨度不能超过7天2024-07-08 00:00:00
report_end_date结束时间string是开始时间和结束时间跨度不能超过7天2024-07-08 00:01:00

示例1，成功

{
    "app_id": 4,
    "set_id": 1,
    "report_begin_date": "2025-02-10 07:00:00",
    "report_end_date": "2025-02-10 07:02:00"
}

返回data.list参数说明

字段名字段说明类型描述
app_id项目ID
zone_id区ID
update_time上报时间
sum_simple_req_num简单请求-读写请求
sum_simple_read_req_num简单请求-读请求
sum_simple_write_req_num简单请求-写请求
…其他字段参考对照表

字段名称和指标名称对照表

字段名指标类型指标名称
sum_simple_read_req_num每分钟简单请求次数读请求
sum_simple_write_req_num写请求
sum_simple_req_num读写请求
sum_api2_proxy_trans_req_num每分钟事务请求次数读写请求
simple_req_max_process_time最大处理时间简单请求
trans_req_max_process_time事务请求
simple_req_average_process_time平均处理时间简单请求
trans_req_average_process_time事务请求
sum_simple_read_req_err_num每分钟错误数简单读请求
sum_simple_write_req_err_num简单些请求
sum_simple_read_resp_err_num简单读响应
sum_simple_write_resp_err_num简单写响应
sum_trans_req_err_num事务读写请求
sum_trans_resp_err_num事务读写响应
sum_batch_get_timeout_cntBatchGet超时数
sum_batch_get_by_part_key_timeout_cntBatchGetbyPartkey超时数
sum_batch_field_get_by_timeout_cntBatchFieldGet超时数
sum_trans_action_failed_numTransAction失败次数
sum_tbus2_tbus_loss_pkg_countTbus2Tbus丢包数
sum_proxy2_tbus_loss_pkg_countProxy2Tbus丢包数
sum_proxy2_api_loss_pkg_countProxy2API丢包数
simple_req_succ_rate每分钟读写成功率简单请求
trans_req_succ_rate事务请求
sum_simple_resp_high_latency_num每分钟大时延请求数简单读写请求
sum_complex_resp_high_latency_num复杂读写请求
sum_simple_read_resp_mid_latency_num每分钟中时延简单请求数读请求
sum_simple_write_resp_mid_latency_num写请求
sum_complex_read_resp_mid_latency_num每分钟中时延复杂请求数读请求
sum_complex_write_resp_mid_latency_num写请求
eth_in_use_mbps每分钟所有机器总流量入流量
eth_out_use_mbps每分钟所有机器总流量出流量
eth_in_out_use_mbps每分钟所有机器总流量出入流量
max_thread_cpu_use每分钟主线程CPU使用率-
used_api_connect_count每分钟进程连接数及剩余容量主进程连接数
max_api_connect_count剩余容量

成功返回 (查询fake_table表，07:01:00 - 07:02 的读写数据)

{
    "code": 0,
    "request_id": "151a5840-230c-4881-9da7-13d42a5ec79d",
    "data": {
        "list": [
            {
                "update_time": "2025-02-10 07:00:00",
                "report_time": 1739142000,
                "proxy_count": 12,
                "sum_simple_req_num": 0,
                "sum_simple_read_req_num": 0,
                "sum_simple_write_req_num": 0,
                "sum_api2_proxy_trans_req_num": 0,
                "simple_req_max_process_time": 0,
                "trans_req_max_process_time": 0,
                "simple_req_average_process_time": 0,
                "trans_req_average_process_time": 0,
                "sum_simple_read_req_err_num": 0,
                "sum_simple_write_req_err_num": 0,
                "sum_simple_read_resp_err_num": 0,
                "sum_simple_write_resp_err_num": 0,
                "sum_trans_req_err_num": 0,
                "sum_trans_resp_err_num": 0,
                "sum_batch_get_timeout_cnt": 0,
                "sum_batch_get_by_part_key_timeout_cnt": 0,
                "sum_batch_field_get_by_timeout_cnt": 0,
                "sum_trans_action_failed_num": 0,
                "sum_tbus2_tbus_loss_pkg_count": 0,
                "sum_proxy2_tbus_loss_pkg_count": 0,
                "sum_proxy2_api_loss_pkg_count": 0,
                "simple_req_succ_rate": 100,
                "trans_req_succ_rate": 100,
                "sum_simple_resp_high_latency_num": 0,
                "sum_complex_resp_high_latency_num": 0,
                "sum_simple_read_resp_mid_latency_num": 0,
                "sum_simple_write_resp_mid_latency_num": 0,
                "sum_simple_read_write_resp_mid_latency_num": 0,
                "sum_complex_read_resp_mid_latency_num": 0,
                "sum_complex_write_resp_mid_latency_num": 0,
                "sum_complex_read_write_resp_mid_latency_num": 0,
                "eth_in_use_mbps": 3,
                "eth_out_use_mbps": 3,
                "eth_in_out_use_mbps": 6,
                "max_thread_cpu_use": 5,
                "used_api_connect_count": 48,
                "max_api_connect_count": 12000,
                "max_remainning_api_connect_count": 11952
            },
            {
                "update_time": "2025-02-10 07:01:00",
                "report_time": 1739142060,
                "proxy_count": 12,
                "sum_simple_req_num": 0,
                "sum_simple_read_req_num": 0,
                "sum_simple_write_req_num": 0,
                "sum_api2_proxy_trans_req_num": 0,
                "simple_req_max_process_time": 0,
                "trans_req_max_process_time": 0,
                "simple_req_average_process_time": 0,
                "trans_req_average_process_time": 0,
                "sum_simple_read_req_err_num": 0,
                "sum_simple_write_req_err_num": 0,
                "sum_simple_read_resp_err_num": 0,
                "sum_simple_write_resp_err_num": 0,
                "sum_trans_req_err_num": 0,
                "sum_trans_resp_err_num": 0,
                "sum_batch_get_timeout_cnt": 0,
                "sum_batch_get_by_part_key_timeout_cnt": 0,
                "sum_batch_field_get_by_timeout_cnt": 0,
                "sum_trans_action_failed_num": 0,
                "sum_tbus2_tbus_loss_pkg_count": 0,
                "sum_proxy2_tbus_loss_pkg_count": 0,
                "sum_proxy2_api_loss_pkg_count": 0,
                "simple_req_succ_rate": 100,
                "trans_req_succ_rate": 100,
                "sum_simple_resp_high_latency_num": 0,
                "sum_complex_resp_high_latency_num": 0,
                "sum_simple_read_resp_mid_latency_num": 0,
                "sum_simple_write_resp_mid_latency_num": 0,
                "sum_simple_read_write_resp_mid_latency_num": 0,
                "sum_complex_read_resp_mid_latency_num": 0,
                "sum_complex_write_resp_mid_latency_num": 0,
                "sum_complex_read_write_resp_mid_latency_num": 0,
                "eth_in_use_mbps": 3,
                "eth_out_use_mbps": 3,
                "eth_in_out_use_mbps": 6,
                "max_thread_cpu_use": 5,
                "used_api_connect_count": 48,
                "max_api_connect_count": 12000,
                "max_remainning_api_connect_count": 11952
            },
            {
                "update_time": "2025-02-10 07:02:00",
                "report_time": 1739142120,
                "proxy_count": 12,
                "sum_simple_req_num": 0,
                "sum_simple_read_req_num": 0,
                "sum_simple_write_req_num": 0,
                "sum_api2_proxy_trans_req_num": 0,
                "simple_req_max_process_time": 0,
                "trans_req_max_process_time": 0,
                "simple_req_average_process_time": 0,
                "trans_req_average_process_time": 0,
                "sum_simple_read_req_err_num": 0,
                "sum_simple_write_req_err_num": 0,
                "sum_simple_read_resp_err_num": 0,
                "sum_simple_write_resp_err_num": 0,
                "sum_trans_req_err_num": 0,
                "sum_trans_resp_err_num": 0,
                "sum_batch_get_timeout_cnt": 0,
                "sum_batch_get_by_part_key_timeout_cnt": 0,
                "sum_batch_field_get_by_timeout_cnt": 0,
                "sum_trans_action_failed_num": 0,
                "sum_tbus2_tbus_loss_pkg_count": 0,
                "sum_proxy2_tbus_loss_pkg_count": 0,
                "sum_proxy2_api_loss_pkg_count": 0,
                "simple_req_succ_rate": 100,
                "trans_req_succ_rate": 100,
                "sum_simple_resp_high_latency_num": 0,
                "sum_complex_resp_high_latency_num": 0,
                "sum_simple_read_resp_mid_latency_num": 0,
                "sum_simple_write_resp_mid_latency_num": 0,
                "sum_simple_read_write_resp_mid_latency_num": 0,
                "sum_complex_read_resp_mid_latency_num": 0,
                "sum_complex_write_resp_mid_latency_num": 0,
                "sum_complex_read_write_resp_mid_latency_num": 0,
                "eth_in_use_mbps": 2,
                "eth_out_use_mbps": 3,
                "eth_in_out_use_mbps": 5,
                "max_thread_cpu_use": 5,
                "used_api_connect_count": 48,
                "max_api_connect_count": 12000,
                "max_remainning_api_connect_count": 11952
            }
        ],
        "total": 3,
        "not_null_total": 3,
        "data_from": [
            {
                "table_name": "proxy_tmonitor_data_set_1_20250210",
                "report_date": "2025-02-10",
                "set_id": 1
            }
        ]
    }
}